UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qJzA0lGDFueZS5BscQ5UkxpvllQaimiWGJk0sVVzzuw='
WHERE
key_id = 'fc8b7e6dc1002932233006e6452a9d0a906046e1cdf62ca44fcb93f9c38ac635'
AND (
token = 'qJzA0lGDFueZS5BscQ5UkxpvllQaimiWGJk0sVVzzuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)