UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K3Hr2J6FdPGSQ2AA30wnDFZKa26HHzf+SYySS+URi/Y='
WHERE
key_id = '53ef9c5b372b525549958850aaca81dbc00a8cd761d3ef0f1435d1aa8233c44d'
AND (
token = 'K3Hr2J6FdPGSQ2AA30wnDFZKa26HHzf+SYySS+URi/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)