UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G/vBdp8iMubmhPouJjhvsL5j9FE5xNGJQ1TPfzGAyIo='
WHERE
key_id = '27c2e2fd3f6634ad95bb225f83e006e6dd7bfdb49eb7dbaa2c196a0c024f2c17'
AND (
token = 'G/vBdp8iMubmhPouJjhvsL5j9FE5xNGJQ1TPfzGAyIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)