UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0s2d8aGrxveuW3Mv5or9K0tgsZAHcSTcdoXp2drk5xg='
WHERE
key_id = '36f01e6bdc78684bb202acb878f2504788081342ecbf60301f1ac4d3057bdd70'
AND (
token = '0s2d8aGrxveuW3Mv5or9K0tgsZAHcSTcdoXp2drk5xg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)