UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mc77UlLkWGgP+X/Ct6pESKO5nwryaECNQpeoRAYuAak='
WHERE
key_id = 'a7686935e7dc7419765abd55dbc5abb1821e55b6d36fa2435d8a059bdce846fe'
AND (
token = 'Mc77UlLkWGgP+X/Ct6pESKO5nwryaECNQpeoRAYuAak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)