UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHIX8vzLZu17ZNJ4DhPLGHhpeTFbitQg9zi/yaXCUHk='
WHERE
key_id = 'a7fb02053d8184098109f03834e971f6ebdb23c7a4ef3e34b5a6ffc3cd9a7192'
AND (
token = 'zHIX8vzLZu17ZNJ4DhPLGHhpeTFbitQg9zi/yaXCUHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)