UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4eCPnjdUNwTRpSDOAbdPUc8GqCEBJR5tiJHOz5wHm+o='
WHERE
key_id = '9563ed4e22ea0c012c741796465a5dcf238fc86374944e0cb12e4d4f5a92f00b'
AND (
token = '4eCPnjdUNwTRpSDOAbdPUc8GqCEBJR5tiJHOz5wHm+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)