UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'abPgshucDf5xRuXdeOBHxePP2G+HUSZpiqSv9w+d4HU='
WHERE
key_id = 'd0dea52cab6b56323374c0430bb32f6e79b33d6e292a9d43ec18aeefdf389bad'
AND (
token = 'abPgshucDf5xRuXdeOBHxePP2G+HUSZpiqSv9w+d4HU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)