UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4aPowz1yW5cJCGgvqsjQ4aqucXU2JbcLUZdeYWy6rDY='
WHERE
key_id = '6d7868fa127fbdc69a44b447faa7ed8df3f68d78244b79df61aa65d80a0fdaa1'
AND (
token = '4aPowz1yW5cJCGgvqsjQ4aqucXU2JbcLUZdeYWy6rDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)