UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vmgvnoiMEuc8QuAF0umlJA8qn3Y/hey1WApWQK3bSTU='
WHERE
key_id = 'f0bf01586f84234a93d764bbf9c1ce74967e2b3ff47c6b82dcb4c5cc6db208a5'
AND (
token = 'vmgvnoiMEuc8QuAF0umlJA8qn3Y/hey1WApWQK3bSTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)