UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DXMmdHr6Db7MGNofxIqMs6ECxebdFoy96Pe0Arwpuqg='
WHERE
key_id = '299939513940253e3a8e80743a12d74564a87d15b8ff88ff8d96a9438a214544'
AND (
token = 'DXMmdHr6Db7MGNofxIqMs6ECxebdFoy96Pe0Arwpuqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)