UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yXwu4pDaU5rM4ci8499jFJb/E9sTnSO+g6n+XlTErh0='
WHERE
key_id = 'fdef7f0108afa5928ed3a639b16e74b4083652671c4827aec307ba39ea879d09'
AND (
token = 'yXwu4pDaU5rM4ci8499jFJb/E9sTnSO+g6n+XlTErh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)