UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZrHER5X1eKsF/Hz8skeCyXr754BKpxlXgZkS5/E/z/4='
WHERE
key_id = '7bb1178245c7f1a62f02a0ecd05ee6c287f95e6b30205762694afab2c0b6f9c5'
AND (
token = 'ZrHER5X1eKsF/Hz8skeCyXr754BKpxlXgZkS5/E/z/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)