UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htgQYIAi+E+4ooF0X/W5LXrQ65aUC1E7yJ100o7wau4='
WHERE
key_id = '5721c073d2352db30aafbf1ea2af1cddd61d3128e748803c097603b3b01bd44f'
AND (
token = 'htgQYIAi+E+4ooF0X/W5LXrQ65aUC1E7yJ100o7wau4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)