UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6xUwVUa3YkNuNodk864jm/q54pSk6PH8rl09O6z/HWU='
WHERE
key_id = 'cd168d7e23c93ee7568f547efa541df1bbc8871b343ecc18ddbfe9c3b68da547'
AND (
token = '6xUwVUa3YkNuNodk864jm/q54pSk6PH8rl09O6z/HWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)