UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n9LO+aGdcalPeERVrdSA6XUV3iPg4QQbha4B8Q6p474='
WHERE
key_id = 'e64cd1f0d4a8af90b2d5c093aff9abc58987be2847043e4ac3e4e035ca80b43b'
AND (
token = 'n9LO+aGdcalPeERVrdSA6XUV3iPg4QQbha4B8Q6p474='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)