UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qCcayZ9Ghi7V0XijrOPJVwl7Fh/j3bcnmqiIV3Po9uo='
WHERE
key_id = 'd4f5240d268cae2aa6a11c51d08e1ca048289625373fb08af234cd4530b7bc1b'
AND (
token = 'qCcayZ9Ghi7V0XijrOPJVwl7Fh/j3bcnmqiIV3Po9uo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)