UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+T7KJf5t3ScAhzHvG5YTrdP0yCOIMPtx6HNRE3seju4='
WHERE
key_id = 'c4d34aad23256eea1fa52d789ba1a3910a261d8244421bd30a0de511615698d0'
AND (
token = '+T7KJf5t3ScAhzHvG5YTrdP0yCOIMPtx6HNRE3seju4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)