UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VbVe7RWSDivXyW9bjqFZ92lW9D5QfOddkfB829oU9C4='
WHERE
key_id = '5027df6b7ceea020bd4996f599a95d53700fea96ab295335cb8d340deccc7ed9'
AND (
token = 'VbVe7RWSDivXyW9bjqFZ92lW9D5QfOddkfB829oU9C4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)