UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8VuFfIVbNKB5EibZwgGyCLvczMAV12fY7EFwPIgvKY='
WHERE
key_id = '5593e03b8a7852fa52d93b05ab27c782117cc303cdb6c047cfbd97a09d80f44b'
AND (
token = 'N8VuFfIVbNKB5EibZwgGyCLvczMAV12fY7EFwPIgvKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)