UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ycZd0dP9tjYqawuA6NV29NI8A7JtVS27GCNP7bS3foM='
WHERE
key_id = 'f156834a0394d0b0aec55f09019aa375b8eb5a87472523138b1914010265f746'
AND (
token = 'ycZd0dP9tjYqawuA6NV29NI8A7JtVS27GCNP7bS3foM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)