UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iVtyJlHaW2FP8EnKXKisOZ7dME7O8LPrn85Pmx0gIHo='
WHERE
key_id = '8f9dcc2b04b1e7da3c9f40b13db793057a994f218c578ccb97e88b5591880e31'
AND (
token = 'iVtyJlHaW2FP8EnKXKisOZ7dME7O8LPrn85Pmx0gIHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)