UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3XcvuHEedZwfvlwhCQ5iFEkvKdNEqDxRAREIMJ8eoBg='
WHERE
key_id = '8e95b87d5d66fd002940e39a709562bb96dc5284d68fe6476340ade4a97926d3'
AND (
token = '3XcvuHEedZwfvlwhCQ5iFEkvKdNEqDxRAREIMJ8eoBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)