UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zjGxhXrTLtvkLl8DSk1hfUXAXtQry6HzS1wr6YOW0nE='
WHERE
key_id = '97e5cc17f84314ed581a1f60042a8cd54fb0a0f424b46e93df9f644497153aa4'
AND (
token = 'zjGxhXrTLtvkLl8DSk1hfUXAXtQry6HzS1wr6YOW0nE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)