UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lgNX8Huaav9DKNzfzRr8ihIQiCl4IJ8RN4E8FRZhizI='
WHERE
key_id = '978a29458e70f559b5f4a8f30ad656b192e1773b510e30404d488a2dcd54f081'
AND (
token = 'lgNX8Huaav9DKNzfzRr8ihIQiCl4IJ8RN4E8FRZhizI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)