UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KKb1dC7Whxbe6i5Jj6Fc1QmWX1INaYITdRe42+aW29I='
WHERE
key_id = '4bc35011d86e94c86f5197a1bf55261de412b576c69ef1e5ada3256dff8c4bfc'
AND (
token = 'KKb1dC7Whxbe6i5Jj6Fc1QmWX1INaYITdRe42+aW29I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)