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