UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4PYJz8N5eeN41poExAw87SZTweER7k6tgiPiGjmUcIo='
WHERE
key_id = 'c4cc14ef7f16e470e5b684347baa74deb121cddba19ee8d66235b7cedb35bf58'
AND (
token = '4PYJz8N5eeN41poExAw87SZTweER7k6tgiPiGjmUcIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)