UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sii52gj3HdsJO7dGhGjjLzKAj0UFAI3Q71OK9r8pc6w='
WHERE
key_id = '29e96841fd92ca3e87e354eaaceeb92d9851d90f37fd6835a0bb138f94c1f123'
AND (
token = 'sii52gj3HdsJO7dGhGjjLzKAj0UFAI3Q71OK9r8pc6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)