UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6K/wd8d6AVL0lNi6hukC3U0JBwePxjVuCIg+BWtRSx4='
WHERE
key_id = 'b01ca8f9e9afae4cab09925258742741aa4735a3ecb9d03ee71caa0c66deb442'
AND (
token = '6K/wd8d6AVL0lNi6hukC3U0JBwePxjVuCIg+BWtRSx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)