UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9GJZIMCAuAVmSvzKHWzkd0EF6EnxPqDxrd2AtOXe6/s='
WHERE
key_id = '22a077d62a16a46aa82d53b5d007bf465df1b52a94df25ddd0c768884952fa67'
AND (
token = '9GJZIMCAuAVmSvzKHWzkd0EF6EnxPqDxrd2AtOXe6/s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)