UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qd7ZYThz8sJmRQ+FyYbpGjxD6W+1OakIG9Pjz6B9D9Y='
WHERE
key_id = 'c144f96a4d654038f847c750e4768c4c6498488bb894176a99ab78fec682bacc'
AND (
token = 'qd7ZYThz8sJmRQ+FyYbpGjxD6W+1OakIG9Pjz6B9D9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)