UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nLPgBPrHLL4tWD8i3kIdDKN7TQugmSuuMg8jEF9EGQY='
WHERE
key_id = '19b92f60680304335c64b3f0c45e0f1856aa17bc9df0d4c6d53b219ec4a837c3'
AND (
token = 'nLPgBPrHLL4tWD8i3kIdDKN7TQugmSuuMg8jEF9EGQY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)