UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZgWgiI0KpxiYyIvQjX1naZ7KK24S7zHye7GKemBVTK8='
WHERE
key_id = '67c672ab575b8f072f8c388e75561ed7d52902cf92e31c8050187dad8fa16706'
AND (
token = 'ZgWgiI0KpxiYyIvQjX1naZ7KK24S7zHye7GKemBVTK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)