UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQycMg0/LwHzRXe6Uwz8w5K7tm/cdKSgpBc3JOAVNyc='
WHERE
key_id = '4b52fe6527fa36189a8eccc7b023b0003a078ecb2e4eda7ad5347d189901fbd8'
AND (
token = 'xQycMg0/LwHzRXe6Uwz8w5K7tm/cdKSgpBc3JOAVNyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)