UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zw/did3f6z/ykCjtR4zk6hRyzWjUQ8ezWWYYsw7QkVg=' 
WHERE 
  key_id = '4d1c64bee147d955b849d1c35db2d5d91b79b79dd76c51d09b3fd3e3c5e06759' 
  AND (
    token = 'zw/did3f6z/ykCjtR4zk6hRyzWjUQ8ezWWYYsw7QkVg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034