UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1iyEwBpGhESghwgqNcW9rczydHQoj4YA023AF5bbuw4='
WHERE
key_id = 'affff9fa954fc8f9dd3269bc228809b81aba7b71fdd99791bacb7e3a8bfd4729'
AND (
token = '1iyEwBpGhESghwgqNcW9rczydHQoj4YA023AF5bbuw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)