UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AVdFjkppTE7vkj7HUh+dXYPeROmkI729zy6JB8qcVWE='
WHERE
key_id = '699eb68d25a7a5ae482da59a8d18e909e8466f47e7c19de7152b3f6373080872'
AND (
token = 'AVdFjkppTE7vkj7HUh+dXYPeROmkI729zy6JB8qcVWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)