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