UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0X8PZ1yfFFLBoR+wA7MhFu2rKFcfVyMcv23ENCCSWvY='
WHERE
key_id = 'a72d04738d8fe839d5ee6af5f7247c54e978dda7f30f91449095b0e223d1a39f'
AND (
token = '0X8PZ1yfFFLBoR+wA7MhFu2rKFcfVyMcv23ENCCSWvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)