UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cai3gCoGWlU+m89/TtLwhOVfK/1YKX9WFpM6aPnmrr8='
WHERE
key_id = '5e296ec13d34bf19344b9b33b7c2c4da25d9b27b2e4559c1b27d4cccac2bc1eb'
AND (
token = 'Cai3gCoGWlU+m89/TtLwhOVfK/1YKX9WFpM6aPnmrr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)