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