UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7LpwsfGtCQeHMVZ52TMPxt4+4IOPRZ3Gim8IRyx+GmA='
WHERE
key_id = 'beac7b165beb8dbd2e4b54d18813d09c75836b97d1f1b2f6cd3e5df170a8b068'
AND (
token = '7LpwsfGtCQeHMVZ52TMPxt4+4IOPRZ3Gim8IRyx+GmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)