UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JgZKXHgHCIw+F93aeQjb9Ej+hD0p4jOOdWGr5bO3rWs='
WHERE
key_id = '5df4d7ae76f1a4b1c8f9216d0ef9f6f6257bdb1ff9d42a82c195dde7226b0688'
AND (
token = 'JgZKXHgHCIw+F93aeQjb9Ej+hD0p4jOOdWGr5bO3rWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)