UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pPAtX6GYmE01WP6kailYPWXwbYqHislz2ByCmmGHkEA='
WHERE
key_id = '8027ea172fdc6bb0e8680510875a1cc2cb419bcbf6627ced0ce2325e73c2234d'
AND (
token = 'pPAtX6GYmE01WP6kailYPWXwbYqHislz2ByCmmGHkEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)